Building the Business Model and Mapping Layer of a Repository in OBIEE

Creating the Business Model and Mapping Layer of a Repository 

In this topic, you use the Oracle BI Administration Tool to build the Business Model and Mapping layer of a repository.

The Business Model and Mapping layer of the Administration Tool defines the business, or logical, model of the data and specifies the mappings between the business model and the Physical layer schemas. This layer is where the physical schemas are simplified to form the basis for the users’ view of the data. The Business Model and Mapping layer of the Administration Tool can contain one or more business model objects. A business model object contains the business model definitions and the mappings from logical to physical tables for the business model.

The main purpose of the business model is to capture how users think about their business using their own vocabulary. The business model simplifies the physical schema and maps the users’ business vocabulary to physical sources. Most of the vocabulary translates into logical columns in the business model. Collections of logical columns form logical tables. Each logical column (and hence each logical table) can have one or more physical objects as sources.

There are two main categories of logical tables: fact and dimension. Logical fact tables contain the measures by which an organization gauges its business operations and performance. Logical dimension tables contain the data used to qualify the facts.

 

If you want to enrich your career and become a professional in OBIEE, then visit Tekslate - a global online training platform: "OBIEE Training"  This course will help you to achieve excellence in this domain.

To build the Business Model and Mapping layer of a repository, you perform the following

steps:

• Create a Business Model
• Examine Logical Joins
• Examine Logical Columns
• Examine Logical Table Sources
• Rename Logical Objects Manually
• Rename Logical Objects Using the Rename Wizard
• Delete Unnecessary Logical Objects
• Create Simple Measures

Create a Business Model

Examine Logical Joins

Examine Logical Columns

Examine Logical Table Sources

Rename Logical Objects Manually

Rename Objects Using the Rename Wizard

Delete Unnecessary Logical Objects

Create Simple Measures

Create a Business Model

1. Right-click the white space in the Business Model and Mapping layer and select New Business Model to open the Business Model dialog box.

2. Enter Sample Sales in the Name field. Leave Disabled checked

3. Click OK. The Sample Sales business model is added to the Business Model and Mapping layer.

4. In the Physical layer, select the following four alias tables: D1 Time D2 Product D3 Customer F1 Revenue Do not select D4 Address at this time.

5 . Drag the four alias table from the Physical layer to the Sample Sales business model in the Business Model and Mapping layer. The tables are added to the Sample Sales business model. Notice that the three-dimension tables have the same icon, whereas the F1 Revenue table has an icon with a # sign, indicating it is a fact table.

For an in-depth understanding of OBIEE click on:

• OBIEE 11g Tutorials
• New Features in OBIEE11g
• Checking Out a Project in OBIEE 11g
• Making Changes to the Repository in OBIEE
• Setting Up a Multiuser Development Environment in OBIEE